<?php

set_include_path(get_include_path() . PATH_SEPARATOR . "$_SERVER[DOCUMENT_ROOT]/ZendGdata-1.12.3/library");
include_once("GoogleSpreadsheet.php");
$gss = new GoogleSpreadsheet("hossain.eps@gmail.com", "021407016");
$gss->setSpreadsheetKey("0At3MtK6gNh_2dEluSk45cTgwRDVIZjRMdGJVUnduc1E");
$gss->setWorksheet("Sheet1");

# this is for all rowdata get
//print_r($gss->getRows());

# this is for row data get
//print_r($gss->getRows('name="Ashiq"'));

# this is for add row data entry all coluam name requierd but value empty is ok
//$row = array("Name"=>"Ashiqur Rahman","Email"=>"ashiqcse@gmail.com","Phone"=>"8801715509874","Address"=>"Dhaka");
//$gss->addRow($row);
# add then search or get data
//print_r($gss->getRows('name="Ashiqur Rahman"'));

# this is for update row data entry all coluam name requierd but value empty is ok
//$row = array("Name"=>"Ashiqur Rahman","Email"=>"ashiqrahman@gmail.com","Phone"=>"8801915509874","Address"=>"Adabor, Dhaka");
# first field is new array and second param is replease value
//$gss->updateRow($row,'name="Ashiqur Rahman"');
# add then search or get data
//print_r($gss->getRows('name="Ashiqur Rahman"'));

# this is for row data delete
//$gss->deleteRow('name="Ashiq"');

# this is for get column name
//print_r($gss->getColumnNames());
?>
